CREATE TABLE jms_dm.dm_cus_active_laxin_volume_cnt_dt (
 input_time date NULL COMMENT "日期",
 customer_code varchar(120) NULL COMMENT "客户编码",
 customer_name varchar(200) NULL COMMENT "客户名称",
 waybill_cnt int(11) NULL COMMENT "客户发货量",
 acc_waybill_cnt int(11) NULL COMMENT "累计发货量",
 date_time date NULL COMMENT "doris 查询时间,分区字段,和input_time的值一致,建包规范"
) ENGINE=OLAP 
DUPLICATE KEY(input_time)
COMMENT "客户拉新活动-发货量"
PARTITION BY RANGE(input_time)
    START ("2023-04-10") END ("2023-04-20") EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(customer_code) BUCKETS 2 
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-180",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2"
);